2015-11-17 - 23212.100 - Spec - Purchase price report #CrystalReportDevelopment

SPECIFICATIONS

23212.100 - Purchase price report

Purpose

Need to create a new report for season and collection as input to pull purchase orders and corresponding purchase price, duty, freight and overhead.

Admin Info

Purpose	Need to create a new report to pull purchase orders and corresponding purchase price, duty, freight and overhead.
Requested By	Lori Miterko
Spec Created By	Venkateswara Reddy D
Spec Created Date	11/17/2015
Spec QA by	Uday Kumar P
Objects	Tables: J_3AMSEA, EKPO, EKKO, KONV, LFA1, MARC, EKPA, T005T.
Document Status	Complete

Estimates

SNo	Activity	Estimation in Hours
1	Research	10
2	Documentation	10
3	Development/ Config	40
5	Unit test in QUA	20
6	NEC Standards	10
	TOTAL	90

References

Prior Tickets

None

Documents

Purchase order price details report.pdf

Spec Changes

SNo	Change Details	Requested By	Requested On	Notes if any
1	Need to align vendor number and description to left side in the report.	Babu Lankipalli	11/30/2015	Email
2	Need to insert shipping instruction description in the report.	Babu Lankipalli	12/01/2015	Email
3	Need to remove the shipping instruction and add Mat Grp in the report.	Babu Lankipalli	12/01/2015	Email
4	Need to multiply the fields(Price,Overhead,Import duty,Freight) with 100 when the company code is 60.	Babu Lankipalli	12/02/2015	IM
5	Need to remove the decimals for the fields Price, Overhead, import duty and freight if the company code in 58 & 60.	Babu Lankipalli	12/08/2015	Email
6	Need to insert conversion rate in the report.	Babu Lankipalli	12/12/2015	IM
7	Need to set the input parameter collection as optional.	Babu Lankipalli	12/16/2015	Email

Functional Requirement

Purpose/WHY:

Email from Babu Lankipalli on 11/13/2015:

In Scope:
Only those Materials are pulled into the report for which season and collection are defined in J_3AMSEA table.

Out of Scope:
Materials for which the season and collection are not defined in J_3AMSEA table.

Solution Summary

1. Need to develop a new PO report based on EKKO, EKPO, J_3AMSEA, LFA1, KONV and MARC ECC tables.
2. Need to establish joins between tables as per report requirement.
3. Need to create the parameters for season and collection.

Test Plan

Test ID	Test Scenario	Expected Results
1	Report Format.	Should be as per NEC crystal standard checklist.
2	Execute Crystal Report in Crystal Designer tool after changes.	Report should execute successfully in Crystal Designer tool.
3	Schedule the Report in NEC BI Launch Pad.	Report should execute successfully in NEC BI Launch Pad.

Solution Details

Issues

None